2016-09-05 - 27959 - Service Request - Retail pro analysis #RetailPro

Service Request:

27959 - Retail Pro Analysis

Problem Summary

Need to fix incorrect Stock Quantity & Stock Values in Retail Pro Analysis Report.

Admin Info

Purpose
 Need to fix incorrect Stock Quantity & Stock Values in Retail Pro Analysis Report.
Requested by
 Deborah Snyderburn
Issue Date
 09/05/2016
Resolved by
 Naveen Gadde
Resolved Date
 12/22/2016
Document Status
 Complete

Detailed Problem Description

Email From Pierre Pazgrat on 18th Oct 2016:

retail issue.PNG

Solution Analysis and Recommendations

1. The stock was showing incorrect values in BW source.
2. The complete historical data was not available in BW source and the data was available from Nov 26, 2015. Data prior to this date was missing in BW.
3. The stock is calculated based on PO Receipts-Sales and need to replace the logic with On hand Quantity as suggested by Retail support team.
4. Need to develop new extractor and map it to existing source to fetch the On hand quantity.
5. Need to perform unit testing in BPD and check the results.
6. Need to make process chain changes to load the data from new extractor.
7. Need to remove all the changes and sync with the production & quality systems.
8. Need to create a new transport request and collect all the changes into it.

Resolution

1. The stock was showing incorrect values in BW source.
2. The complete historical data was not available in BW source and the data was available from Nov 26, 2015. Data prior to this date was missing in BW.
3. The stock is calculated based on PO Receipts-Sales and need to replace the logic with On hand Quantity as suggested by Retail support team.
4. Need to develop new extractor and map it to existing source to fetch the On hand quantity.
5. The following document specifies the design to develop new extractor:
Retail fileds.xlsx

6. The following document specifies the unit testing results:
Retail Stock Values - Grid Level.xlsx
7. Need to make process chain changes to load the data from new extractor.
8. Need to remove all the changes and sync with the production & quality systems.
9. Need to create a new transport request and collect all the changes into it.
10. The following attachment specifies the test results in BPQ:
Retail Quality Test.png

11. The following attachment shows the final testing performed in BPP:
Retail Prd1.png

Release Information

Specified in the attached Release Notes.